翻訳と辞書
Words near each other
・ Dimethyl disulfide
・ Dimethyl ether
・ Dimethyl ether (data page)
・ Dimethyl fumarate
・ Dimethyl maleate
・ Dimethyl malonate
・ Dimethyl methylphosphonate
・ Dimethyl oxalate
・ Dimemorfan
・ Dimenhydrinate
・ DiMenna–Nyselius Library
・ Dimenoxadol
・ Dimensia in Excelsis
・ Dimension
・ Dimension (company)
Dimension (data warehouse)
・ Dimension (disambiguation)
・ Dimension (film)
・ Dimension (graph theory)
・ Dimension (metadata)
・ Dimension (shampoo)
・ Dimension (song)
・ Dimension (vector space)
・ Dimension 4
・ Dimension 5
・ Dimension 5 (album)
・ Dimension 5 (film)
・ Dimension Costeña
・ Dimension Data Holdings
・ Dimension Data Pro-Am


Dictionary Lists
翻訳と辞書 辞書検索 [ 開発暫定版 ]
スポンサード リンク

Dimension (data warehouse) : ウィキペディア英語版
Dimension (data warehouse)

A dimension is a structure that categorizes facts and measures in order to enable users to answer business questions. Commonly used dimensions are people, products, place and time.〔"(Oracle Data Warehousing Guide )", Oracle Corporation, retrieved 09 June 2014〕〔(Definition: Dimension )" Search Data Management, TechTarget, retrieved 09 June 2014〕
In a data warehouse, dimensions provide structured labeling information to otherwise unordered numeric measures. The dimension is a data set composed of individual, non-overlapping data elements. The primary functions of dimensions are threefold: to provide filtering, grouping and labelling.
These functions are often described as "slice and dice". Slicing refers to filtering data. Dicing refers to grouping data. A common data warehouse example involves sales as the measure, with customer and product as dimensions. In each sale a customer buys a product. The data can be sliced by removing all customers except for a group under study, and then diced by grouping by product.
A dimensional data element is similar to a categorical variable in statistics.
Typically dimensions in a data warehouse are organized internally into one or more hierarchies. "Date" is a common dimension, with several possible hierarchies:
*"Days (are grouped into) Months (which are grouped into) Years",
*"Days (are grouped into) Weeks (which are grouped into) Years"
*"Days (are grouped into) Months (which are grouped into) Quarters (which are grouped into) Years"
*etc.
==Types==


抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)
ウィキペディアで「Dimension (data warehouse)」の詳細全文を読む



スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース

Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.